COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2020-11-17T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... variazione_totale_positivi nuovi_positivi dimessi_guariti deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note
5623 2020-11-17T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1505 227 1732 29024 ... 991 1698 12964 971 27716.0 16975.0 44691 835534 577818.0 NaN
5624 2020-11-17T17:00:00 ITA 9 Toscana 43.769231 11.255889 1792 277 2069 52083 ... 301 2361 28078 1967 66908.0 17289.0 84197 1363146 870134.0 effettuati 48180 tamponi rapidi antigenici di...
5625 2020-11-17T17:00:00 ITA 10 Umbria 43.106758 12.388247 368 70 438 10806 ... 5 351 7991 275 5465.0 14045.0 19510 367077 206060.0 Si fa presente come nel computo dei ricoverati...
5626 2020-11-17T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 152 17 169 1994 ... -103 154 3079 257 4884.0 615.0 5499 51410 30178.0 NaN
5627 2020-11-17T17:00:00 ITA 5 Veneto 45.434905 12.338452 1980 266 2246 60825 ... 373 3124 39928 2967 27936.0 78030.0 105966 2590427 1000577.0 Tamponi antigenici 623.625 Totale popolazione ...

5 rows × 21 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives NewPositives Recovered Deaths Diagnostico Screening TotalCases NoOfTests casi_testati note Pop
Date
2020-11-13 2020-11-13 Veneto 45.434905 12.338452 1831 219 2050 55238 57288 2533 3605 34454 2764 26878.0 67628.0 94506 2529005 978328.0 Tamponi antigenici 543.099 4905854
2020-11-14 2020-11-14 Veneto 45.434905 12.338452 1869 228 2097 57608 59705 2417 3578 35563 2816 27166.0 70918.0 98084 2547409 984607.0 Tamponi antigenici 577.984 4905854
2020-11-15 2020-11-15 Veneto 45.434905 12.338452 1934 241 2175 59331 61506 1801 2792 36525 2845 27442.0 73434.0 100876 2562531 989643.0 Tamponi antigenici 588.190 4905854
2020-11-16 2020-11-16 Veneto 45.434905 12.338452 1985 252 2237 60461 62698 1192 1966 37277 2867 27639.0 75203.0 102842 2571888 993185.0 Tamponi antigenici 595.200 4905854
2020-11-17 2020-11-17 Veneto 45.434905 12.338452 1980 266 2246 60825 63071 373 3124 39928 2967 27936.0 78030.0 105966 2590427 1000577.0 Tamponi antigenici 623.625 Totale popolazione ... 4905854

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together